alter java source "com/prism/demo/i/DEMOj" compile;
show errors

CREATE OR REPLACE PACKAGE DEMOj AS
  PROCEDURE STARTUP;
  PROCEDURE HELLO(name VARCHAR2, n NUMBER);
  PROCEDURE HELLO(name VARCHAR2, n NUMBER, msgs LONG RAW);
  PROCEDURE HELLO;
  PROCEDURE UPLOAD_FORM;
  PROCEDURE DOWNLOAD;
  PROCEDURE DOCS_LOAD;
  PROCEDURE UPLOAD(binaryfiles long raw, OK long raw);
  PROCEDURE INPUT;
  PROCEDURE TEXTAREA;
  PROCEDURE OUTPUT(b long raw, OK long raw);
  PROCEDURE OUTPUT_TEXTAREA(b CLOB, OK long raw);
  PROCEDURE COOKIE;
  PROCEDURE REDIRECT;
  PROCEDURE ACTION_REDIRECT;
  PROCEDURE EXPIRES;
  PROCEDURE EXCEL;
  PROCEDURE LIST;
  PROCEDURE LIST_JXTP;
  PROCEDURE QUOTES1;
  PROCEDURE QUOTES2;
  PROCEDURE STATUS;
  PROCEDURE NOTAUTHORIZED;
  PROCEDURE XFORMS(post_xml varchar2);
  PROCEDURE FLEX(name_array long raw,
                 value_array long raw);
  PROCEDURE ACTION;
  PROCEDURE ACTION(xsl varchar2);
  PROCEDURE testXMLType;
  PROCEDURE testXMLTypeNative;
  
END DEMOj;
/
show errors

CREATE OR REPLACE PACKAGE BODY DEMOj AS
  PROCEDURE STARTUP
        AS LANGUAGE JAVA
        NAME 'com.prism.demo.i.DEMOj.STARTUP()';
  PROCEDURE HELLO(name VARCHAR2, n NUMBER)
        AS LANGUAGE JAVA
        NAME 'com.prism.demo.i.DEMOj.HELLO(java.lang.String, int)';
  PROCEDURE HELLO(name VARCHAR2, n NUMBER, msgs LONG RAW)
        AS LANGUAGE JAVA
        NAME 'com.prism.demo.i.DEMOj.HELLO(java.lang.String, int, byte [])';
  PROCEDURE HELLO
        AS LANGUAGE JAVA
        NAME 'com.prism.demo.i.DEMOj.HELLO()';
  PROCEDURE UPLOAD_FORM
        AS LANGUAGE JAVA
        NAME 'com.prism.demo.i.DEMOj.UPLOAD_FORM()';
  PROCEDURE DOCS_LOAD
        AS LANGUAGE JAVA
        NAME 'com.prism.demo.i.DEMOj.DOCS_LOAD()';
  PROCEDURE DOWNLOAD
        AS LANGUAGE JAVA
        NAME 'com.prism.demo.i.DEMOj.DOWNLOAD()';
  PROCEDURE UPLOAD(binaryfiles long raw, OK long raw)
        AS LANGUAGE JAVA
        NAME 'com.prism.demo.i.DEMOj.UPLOAD(byte [], byte [])';
  PROCEDURE INPUT
        AS LANGUAGE JAVA
        NAME 'com.prism.demo.i.DEMOj.INPUT()';
  PROCEDURE TEXTAREA
        AS LANGUAGE JAVA
        NAME 'com.prism.demo.i.DEMOj.TEXTAREA()';
  PROCEDURE OUTPUT(b long raw, OK long raw)
        AS LANGUAGE JAVA
        NAME 'com.prism.demo.i.DEMOj.OUTPUT(byte[] , byte[])';
  PROCEDURE OUTPUT_TEXTAREA(b CLOB, OK long raw)
        AS LANGUAGE JAVA
        NAME 'com.prism.demo.i.DEMOj.OUTPUT_TEXTAREA(oracle.sql.CLOB , byte [])';
  PROCEDURE COOKIE
        AS LANGUAGE JAVA
        NAME 'com.prism.demo.i.DEMOj.COOKIE()';
  PROCEDURE REDIRECT
        AS LANGUAGE JAVA
        NAME 'com.prism.demo.i.DEMOj.REDIRECT()';
  PROCEDURE ACTION_REDIRECT
        AS LANGUAGE JAVA
        NAME 'com.prism.demo.i.DEMOj.ACTION_REDIRECT()';
  PROCEDURE EXPIRES
        AS LANGUAGE JAVA
        NAME 'com.prism.demo.i.DEMOj.EXPIRES()';
  PROCEDURE EXCEL
        AS LANGUAGE JAVA
        NAME 'com.prism.demo.i.DEMOj.EXCEL()';
  PROCEDURE LIST
        AS LANGUAGE JAVA
        NAME 'com.prism.demo.i.DEMOj.LIST()';
  PROCEDURE LIST_JXTP
        AS LANGUAGE JAVA
        NAME 'com.prism.demo.i.DEMOj.LIST_JXTP()';
  PROCEDURE QUOTES1
        AS LANGUAGE JAVA
        NAME 'com.prism.demo.i.DEMOj.QUOTES1()';
  PROCEDURE QUOTES2
        AS LANGUAGE JAVA
        NAME 'com.prism.demo.i.DEMOj.QUOTES2()';
  PROCEDURE STATUS
        AS LANGUAGE JAVA
        NAME 'com.prism.demo.i.DEMOj.STATUS()';
  PROCEDURE NOTAUTHORIZED
        AS LANGUAGE JAVA
        NAME 'com.prism.demo.i.DEMOj.NOTAUTHORIZED()';
  PROCEDURE XFORMS(post_xml varchar2)
        AS LANGUAGE JAVA
        NAME 'com.prism.demo.i.DEMOj.XFORMS(java.lang.String)';
  PROCEDURE FLEX(name_array long raw,
                 value_array long raw)
        AS LANGUAGE JAVA
        NAME 'com.prism.demo.i.DEMOj.FLEX(byte[],byte[])';
  PROCEDURE ACTION IS
  BEGIN
     ACTION('samples');
  END ACTION;
  PROCEDURE ACTION(xsl varchar2)
        AS LANGUAGE JAVA
        NAME 'com.prism.demo.i.DEMOj.ACTION(java.lang.String)';
  PROCEDURE testXMLType
        AS LANGUAGE JAVA
        NAME 'com.prism.demo.i.DEMOj.testXMLType()';
  PROCEDURE testXMLTypeNative
        AS LANGUAGE JAVA
        NAME 'com.prism.demo.i.DEMOj.testXMLTypeNative()';
END DEMOj;
/
show errors
exit
